import pandas as pd
pd.set_option('display.unicode.east_asian_width',True)

df = pd.read_excel('城镇单位就业人员年平均工资.xlsx',sheet_name='按登记注册类型',index_col=0)
df.drop('A10',inplace=True)
print('删除数据来源：国家统计局以后的数据：\n',df)
# df1 = df.loc['2001-2020年外商投资单位平均工资'] =[112089,112089,112089,112089,112089,112089,
#                                                112089,112089,112089,112089,112089,112089,112089,
#                                                112089,112089,112089,112089,112089,112089,112089]
#
# print(df1)
#
# writer = pd.ExcelWriter('城镇单位就业人员年平均工资.xlsx')
# df.to_excel(writer,sheet_name='按登记注册类型')
# writer._save()

'xingbie':[,'b','b','g','g'],